CREATE VIEW [dbo].[vAddressCorrespondenceReport]
AS
SELECT   ContactKey,
         FullAddressKey,
         1 AS AddressCategory,
         PhysicalAddressKey AS AddressKey
FROM     FullAddress
UNION
SELECT   ContactKey,
         FullAddressKey,
         3 AS AddressCategory,
         FaxAddressKey AS AddressKey
FROM     FullAddress
UNION
SELECT   ContactKey,
         FullAddressKey,
         4 AS AddressCategory,
         EmailAddressKey AS AddressKey
FROM     FullAddress

GO